from openpyxl import load_workbook
from openpyxl import Workbook
from mytool.office.excel import RawExcel
from mytool.system.direcotry import Direcotry

# s = Sheet(r'D:\工作\CC\01-巡检\zabbix202001月份巡检表.xlsx')
# print(s.lwb)
# for _ in s.lwb:
#     print(_)
d = Direcotry(r'D:\工作\CC\01-巡检')
f = d.get_files(pattern='zabbix2020')
count = 0
for _ in f:
    r = RawExcel(read_path=_)
    for name in r.get_all_sheet_name():
        print(name.title)
        count += 1

print(count)